package org.niit.dao

import org.niit.util.JDBCUtil

/**
 * Date:2025/6/4
 * Author：Ys
 * Description:
 */
class AreaAdDao {

  def insertAreaCityAd(day:String,  area:String, city:String, ad:String, count:Int): Unit = {


    val conn = JDBCUtil.getConnection

    JDBCUtil.executeUpdate(conn, "insert into area_city_ad_count values(?,?,?,?,?) on duplicate key update count = count + ?",
      Array(day, area, city, ad, count, count) )

    conn.close()


  }

}
